Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# MAX_ENABLED_ROLES

Property | Description
--- | ---
Parameter type | Integer
Default value | `30`
Modifiable | No
Range of values | 0 to 148
Basic | No

Note: This parameter is deprecated. It is retained for backward compatibility only.

`MAX_ENABLED_ROLES` specifies the maximum number of database roles that users can enable, including roles contained within other roles. The actual number of roles that users can enable is 2 plus the value of `MAX_ENABLED_ROLES`, because each user has two additional roles, `PUBLIC` and the user's own role.

For example, if `MAX_ENABLED_ROLES` is set to `5`, then user `HR` can have seven roles enabled (the five enabled by `MAX_ENABLED_ROLES`, plus `PUBLIC` and `HR`).